﻿CREATE TABLE [trUser].[tblDriverCompanies] (
    [IDDriverCompany] BIGINT   IDENTITY (1, 1) NOT NULL,
    [IDDriver]        BIGINT   NOT NULL,
    [IDCompany]       BIGINT   NOT NULL,
    [DateLinked]      DATETIME NULL,
    [DateUnlinked]    DATETIME NULL,
    [DateCreated]     DATETIME CONSTRAINT [DF_tblDriverCompanies_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]     DATETIME NULL,
    [DateInactive]    DATETIME NULL,
    CONSTRAINT [PK_tblDriverCompanies] PRIMARY KEY CLUSTERED ([IDDriverCompany] ASC)
);

